<clickhouse>
    <query_log>
        <partition_by>toYYYYMM(event_date)</partition_by>
        <ttl>event_date + INTERVAL 30 DAY DELETE</ttl>
        <order_by>event_date, event_time, initial_query_id</order_by>
        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <storage_policy>policy1</storage_policy>
        <settings>storage_policy='policy2', ttl_only_drop_parts=1</settings>
    </query_log>
</clickhouse>
